<?php include ("header.php") ?>
<html>
    <body>
        <div id="acYrDialog">
            <form>
                <table>
                    <tr>
                        <td><p><label>Academic Year:</label></td><td><input class="with-helper input-control text" id="acYrName" type="text" autofocus="" placeholder="ex: 2012/2013"/></p></td>
                    </tr>
                    <tr>
                    <div class="input-control text span5">
                        <td><p><label>Start Date:</label></td><td><input type="text" autofocus="" id="startDate" placeholder="Start Date"/></p></td>
                    </div>
                    </tr>
                    <tr>
                    <div class="input-control text span5">
                        <td><p><label>End Date:</label></td><input type="text" autofocus="" id="endDate" placeholder="End Date"/></p></td>
                    </div>
                    </tr>
                </table>
            </form>
            <button onclick=""/>
        </div>
    </body>
</html>
<?php
include 'dbconnection.php';
$sql = "SELECT DISTINCT * FROM acedamic_year";
$result = mysql_query($sql);
?>
<html><body><div class="span5"><form><table style="border-color: white;">
                    <tr><td><p><label>Task:</label></td><td><input class="with-helper input-control text" name="taskName" type="text" autofocus="" placeholder="ex: 2012/2013"/></p></td></tr>
                    <tr><td><p><label>Type:</label></td><td><select type="text" autofocus="" name="type" placeholder=""><option value="Reminder" name="reminder"></option><option value="Assignment" name="assignment"></option></select></p></td></tr>
                    <tr><td><p><label>Start time:</label></td><td><input class="with-helper input-control text" type="text" autofocus="" name="s_time" placeholder=""/></p></td></tr>
                    <tr><td><p><label>End time:</label></td><td><input class="with-helper input-control text" name="e_time" type="text" autofocus="" placeholder=""/></p></td></tr>
<tr><td><p><label>Description:</label></td><td><input class="with-helper input-control text" name="desc" type="text" autofocus="" placeholder=""/></p></td></tr>                     
       <?php
                            echo "<select name='year'>";
                            while ($row = mysql_fetch_array($result)) {echo "<option value='" . $row['ayear_name'] . "'>" . $row['ayear_name'] . "</option>";}
                            echo "</select>";?>
                </table></form></div></body></html>

        <div class="modal fade" id="signIn" tabindex="-1" role="dialog" aria-labelledby="signInLabel" aria-hidden="true">
            <div class="modal-dialog">
                <div class="modal-content">
                    <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                        <h4 class="modal-title">Sign In</h4>
                    </div>
                    <div class="modal-body">
                        <form action=""  class="form-signin">
                            <h2 class="form-signin-heading">Please sign in</h2>
                            <input id="user" type="text" class="form-control" placeholder="Username" autofocus>
                            <input id="password" type="password" class="form-control" placeholder="Password">
                        </form>
                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-primary" onclick="login()">Sign In</button>
                    </div>
                </div><!-- /.modal-content -->
            </div><!-- /.modal-dialog -->
        </div><!-- /.modal -->
        <html><body><div class=""><form><table style="border-color: white;">
                    <tr><td><p><label>Task:</label></td><td><input class="with-helper input-control text" name="taskName" type="text" autofocus="" placeholder="ex: 2012/2013"/></p></td></tr>
                    <tr><td><p><label>Type:</label></td><td><select type="text" autofocus="" name="type" placeholder=""><option value="Reminder" name="reminder"></option><option value="Assignment" name="assignment"></option></select></p></td></tr>
                    <tr><td><p><label>Start time:</label></td><td><input class="with-helper input-control text" type="text" autofocus="" name="s_time" placeholder=""/></p></td></tr>
                    <tr><td><p><label>End time:</label></td><td><input class="with-helper input-control text" name="e_time" type="text" autofocus="" placeholder=""/></p></td></tr>
<tr><td><p><label>Description:</label></td><td><input class="with-helper input-control text" name="desc" type="text" autofocus="" placeholder=""/></p></td></tr>                     
       <?php
                            echo "<select name='year'>";
                            while ($row = mysql_fetch_array($result)) {echo "<option value='" . $row['ayear_name'] . "'>" . $row['ayear_name'] . "</option>";}
                            echo "</select>";?>
                </table></form></div></body></html>